Back to Main Menu

Import Chart of Accounts

The Chart of Accounts within Assetic may be synchronised with your Finance System via the Data Exchange integration API.

 

It is assumed that the Finance System is the master and Assetic replicates the account structure.

 

There are two aspects to the integration:

  1. Initial setup of Chart of Accounts

  2. Maintaining Chart of Accounts

 

Initial Setup

When creating the Chart of Accounts the prerequisite configuration must be in place to support account creation. Refer to the following article on Configuration.

 

Using Data Exchange the Chart of Accounts can be imported from a spreadsheet (csv format) that has the following fields:

  • Ledger (as defined in Assetic)

  • Account name

  • Account Type (as listed in Assetic)

  • Account number

  • Initial Balance (optional, default $0.00 and applicable only to Capital Account type)

 

Refer to the Data Exchange integration article to learn how to automate data exchange if required.

 

Using Data Exchange ensures that the accounts are correctly entered (assumes that the accounts were exported to the spreadsheet from the Finance System to avoid human error with data entry)

 

Maintaining Accounts

On a periodic basis it may be necessary to crosscheck account numbers and account types to detect and report discrepancies. These discrepancies may be:

 

There are new accounts in the Finance System that require importing into Assetic. The process described above in Initial Setup can be used to achieve this

 

There are now accounts in Assetic that are obsolete. These accounts should be ignored as an account may not be deleted from Assetic unless it has no journals against it.